* use UCDP Peace agreement dataset
import excel "/Users/jthomas/Dropbox/working papers/gender and peace agreements/Sisters_APSR/R&R/ucdp-peace-agreements-191.xlsx", sheet("Dataset") firstrow clear
rename E JTduplicated
destring paid, replace
destring year, replace

gen agtid=.
*oslo agreement
replace agtid=309  if paid==1082
*geneva agreement
replace agtid= 393 if paid==1102
*Groot Schuur Minute 
replace agtid= 395 if paid==1393
*general agenda el salvador
replace agtid=387  if paid==1103
*Agreement on Human rights
replace agtid=265  if paid==1104
*Pretoria Minute
replace agtid=490  if paid==1273
*Banjul III
replace agtid=635  if paid==1301
*bamako
replace agtid=634  if paid==1075
*Banjul IV
replace agtid=633  if paid==1100
*Tamanrasset--6/1/91
replace agtid=206  if paid==1039
*Honiara declaration
replace agtid=570  if paid==1076
*Acuerdo Final
replace agtid=149  if paid==1079
*Nsele ceasefire 12/7/92
replace agtid=469  if paid==1320
*The mexico accord
replace agtid=289  if paid==1083
*The mexico agreements
replace agtid=456  if paid==1105
*Protocol on agreed/detailed agenda
replace agtid=46  if paid==1308
***FOLLOW UP*Bicesse Agreement *There were other bicesse accords for angola that same day; (1316; 1319; 1319;  1317)
replace agtid=207  if paid==1022
*Brioni
replace agtid=422  if paid==1069
*Querétaro
replace agtid=383  if paid==1084
*New York
replace agtid=467  if paid==1106
*compressed negotiations
replace agtid=601  if paid==1107
*basic principles
replace agtid=493  if paid==1302
**FOLLOW UP *paris agreement *** there are other paris agreement accords (243; 378; 364)
replace agtid=252  if paid==1113
*yamoussoukro
replace agtid=564  if paid==1062
*Agreement on Establishment and Recognition of Political Parties
replace agtid=494  if paid==1303
*CODESA
replace agtid=186  if paid==1395
*New york act I
replace agtid=465  if paid==1108
*New york act II
replace agtid=1020  if paid==1109
*Chapultepec
replace agtid=474  if paid==1110
*agreement Electoral act 12/3/1992
replace agtid=495  if paid==1306
*pacte national
replace agtid=637  if paid==1040
*The Protocol of Agreement between Rwanda and RPF
replace agtid=503  if paid==1321
*record of understanding
replace agtid=445  if paid==1396
*AGP accord;   general agreement for mozambique (10/4/1992)
replace agtid=392  if paid==1020
*El Geneina agreement (chad)
replace agtid=.  if paid==1042
*The Protocols of Agreement between the Government of the Republic of Rwanda and the Rwandese Patriotic Front on Power-Sharing within the Framework of a Broad-Based Transitional Government,
replace agtid=1343  if paid==1523
*Bodoland autonomous council act
replace agtid=30  if paid==1071
*Islamabad accord 3/7/1993
replace agtid=409  if paid==1128
*Addis Ababa Agreement
replace agtid=216  if paid==1576
*Jalalabad agreement
replace agtid=.  if paid==1132
*The Protocol of Agreement between the Government of the Republic of Rwanda and the Rwandese Patriotic Front on the Repatriation of Refugees and the Resettlement of Displaced Persons,
replace agtid=505  if paid==1323
*Paris Accord- Niger
replace agtid=.  if paid==1036
*The Governor's Island agreement
replace agtid=27 if paid==1066
*Cotonou Peace Agreement
replace agtid=346  if paid==1015
*The Protocol Agreement between the Government of the Republic of Rwanda and the Rwandese Patriotic Front on the integration of Armed Forces and The Protocol of Agreement between the Government of the Republic of Rwanda and the Rwandese Patriotic Front on Miscellaneous Issues and Final Provisions
replace agtid=506  if paid==1325
*Arusha Accords
replace agtid=475  if paid==1002
*Memorandum of Settlement - 23 August 1993
replace agtid=631  if paid==1121
*Declaration of Principles on Interim Self-Government Arrangements/ Oslo Agreement
replace agtid=357  if paid==1133
*Tripoli 1 Agreement (Chad)-- could be tripoli agreement of 2002-- agtid=910
replace agtid=.  if paid==1043
*Interim Constitution
replace agtid=407  if paid==1397
*The Framework Agreement for the Resumption of Negotiations between the Government of Guatemala and the Guatemalan National Revolutionary Unity
replace agtid=382  if paid==1085
*The Washington Agreement
replace agtid=608  if paid==1072
*FOLLOWUP**Nairobi Declaration on National Reconciliation*** 
replace agtid=907  if paid==1142
*The Agreement on a Timetable for Negotiations on a Firm and Lasting Peace in Guatemala
replace agtid=258  if paid==1086
*The Comprehensive Agreement on Human Rights
replace agtid=334  if paid==1087
*Declaration on measures for a political settlement of the Georgian/Abkhaz conflict
replace agtid=361  if paid==1130
*Agreement between the Great Socialist People's Libyan Arab Jamahiriya and the Republic of Chad concerning the practical modalities for the implementation of the Judgment delivered by the International Court of Justice on 3 February 1994
replace agtid=237  if paid==1421
*Agreement on the Gaza Strip and the Jericho Area
replace agtid=281  if paid==1134
*The Agreement on the Resettlement of Population Groups Uprooted by the Armed Conflict
replace agtid=273  if paid==1088
*The Agreement for the Establishment of the Commission to Clarify Past Human Rights Violations and Acts of Violence that have Caused the Guatemalan Population to Suffer
replace agtid=296  if paid==1089
*Bangui-2 Agreement
replace agtid=.  if paid==1044
*Agreement on Preparatory Transfer of Powers and Responsibilities Between Israel and the PLO
replace agtid=271  if paid==1135
*Honiara Commitments to Peace
replace agtid=639  if paid==1076
*Akosombo Peace Agreement
replace agtid= 304 if paid==1016
*Ouagadougou Accord
replace agtid=203  if paid==1037
*Abeche agreement
replace agtid=.  if paid==1116
*Lusaka
replace agtid=439  if paid==1004
*Accord de paix et reconcilition
replace agtid=245  if paid==1009
*agreement on identity
replace agtid=283  if paid==1090
*accord e'tablissant une paix definitive
replace agtid=204  if paid==1038
*protocol on fundamental principles
replace agtid=518  if paid==1144
*Abuja
replace agtid=194  if paid==1017
*Israeli-Palestinian Interm agreement
replace agtid=410  if paid==1136
*GRP-RAM
replace agtid=640  if paid==1058
*Erdut
replace agtid=563  if paid==1074
*Dougia (Chad)
replace agtid=.  if paid==1117
*Dayton
replace agtid=1320  if paid==1073
*San Andres
replace agtid=214  if paid==1070
*Agreement on socioeconomic aspects
replace agtid=.  if paid==1131
*Mahipar agreement (afghanistan)
replace agtid=.  if paid==1131
*Abuja II Peace Agreement
replace agtid=551  if paid==1018
*Mindanao agreement
replace agtid=479  if paid==1064
*Strengtheining civilian power
replace agtid=292  if paid==1092
*Abidjan
replace agtid=476  if paid==1011
*Definitive ceasefire
replace agtid=253  if paid==1093
*Constitutional Reforms
replace agtid=263  if paid==1094
*Basis for legal integration of URNG
replace agtid=278  if paid==1095
*Agreement between the President of the Republic of Tajikistan
replace agtid=239  if paid==1147
*Firm and Lasting peace
replace agtid=254  if paid==1081
*Implementation, compliance
replace agtid=284  if paid==1097
*redeployment in Hebron
replace agtid=500  if paid==1137
*Statute of the Commission on National Reconciliation
replace agtid=549  if paid==1312
*memorandum on the basis for normalization
replace agtid=454  if paid==1123
*protocol on political issues
replace agtid=514  if paid==1315
*Moscow declaration
replace agtid=388  if paid==1119
*National Reconciliation agreement (chad)
replace agtid=.  if paid==1045
*Chittagong hill tracts
replace agtid=238  if paid==1057
*Cairo declaration on somalia
replace agtid=317  if paid==1060
*Good Friday Agreement
replace agtid=556  if paid==1063
*Donya agreement (chad)
replace agtid=.  if paid==1046
*Wye River memorandum
replace agtid=592  if paid==1138
*Acta presidencia
replace agtid=212  if paid==1125
*Abuja agreement
replace agtid=218  if paid==1019
*Common agenda for the path
replace agtid=155  if paid==1329
*kosovo peace agreement
replace agtid=6  if paid==.
*reconciliation agreement (chad)
replace agtid=.  if paid==1118
*Lome peace agreement
replace agtid=478  if paid==1013
*Lusaka accord
replace agtid=319  if paid==.
*Sharm el Sheikh
replace agtid=587  if paid==1140
*Accord de Cessez-le-Feu et de Cessation des Hostilités
replace agtid=201  if paid==1026
*Accord Cadre de Reforme et de Concorde Civile
replace agtid=197  if paid==1010
*The Famboni Declaration
replace agtid= 619 if paid==1024
*Arusha Peace and Reconciliation Agreement for Burundi
replace agtid=306  if paid==1003
*Abuja Ceasefire Agreement
replace agtid=320  if paid==1143
*Agreement between the Government of the State of Eritrea and the Government of the Federal Democratic Republic of Ethiopia
replace agtid=221  if paid==1008
*Los Pozos Agreement
replace agtid=145  if paid==1122
*The Famboni II Agreement
replace agtid=621  if paid==1025
*Declaration of Fundamental Principles for the Inter-Congolese dialogue
replace agtid=356  if paid==1288
*Accord de reforme et concorde civile
replace agtid=624  if paid==1146
*Agreement on Peace between the government of the Republic of the Philippines and the Moro Islamic Liberation Front
replace agtid=269  if paid==1332
*The Ohrid Agreement
replace agtid=381  if paid==1098
*Bougainville Peace Agreement
replace agtid=312  if paid==1080
*Tripoli 2 agreement
replace agtid=910  if paid==616
*Los Pozos Accord
replace agtid=157  if paid==1122
*Memorandum of Understanding or Memorandum of Intent
replace agtid=978  if paid==1126
*Political agreement on consensual management of the transition in the Democratic Republic of the Congo
replace agtid=623  if paid==1291
*Machakos Protocol
replace agtid=440  if paid==1277
*Ceasefire Agreement between the Transitional Government of Burundi and the Conseil national pour la défense de ladémocrati
replace agtid=321  if paid==1065
*Cessation of Hostilities Framework Agreement
replace agtid=325  if paid==1111
*Global and Inclusive Agreement on the Transition in the Democratic Republic of Congo
replace agtid=394  if paid==1005
*Yumbe Peace Agreement
replace agtid=649  if paid==1145
*Linas-Marcoussis Peace Accords
replace agtid=436  if paid==1139
*Accra II
replace agtid=195  if paid==1292
*Inter-congolese political negotiation
replace agtid=404  if paid==1290
*Accra Ceasefire agreement
replace agtid=259  if paid==1141
*Accra Peace agreement
replace agtid=338  if paid==1101
*Agreement on Security Arrangements During the Interim Period
replace agtid=275  if paid==1278
*The Pretoria Protocol on Political, Defence and Security Power Sharing in Burundi
replace agtid=582  if paid==1287
*The Pretoria Protocol on Outstanding Political, Defence and Security Power Sharing Issues in Burundi
replace agtid=584  if paid==1285
*The Global Ceasefire agreement between Transitional Government and the Forces pour la defence de la democratie
replace agtid=568  if paid==1099
*Agreement on the transitional arrangements in the Comoros
replace agtid=618  if paid==1127
*Framework on Wealth Sharing During the Pre-Interim
replace agtid=385  if paid==1310
*Protocol Between the GOS and SPLM on Power Sharing
replace agtid=498  if paid==1279
*The Protocol Between the GOS and SPLM on the Resolution of Conflict in Abyei Area
replace agtid=583  if paid==1280
*The Protocol Between the GOS and SPLM on the Resolution of Conflict in Southern Kordofan/Nuba Mountains and Blue Nile States
replace agtid=496  if paid==1281
*Accra III
replace agtid=210  if paid==1283
*Accord general de paix entre le gouvernement de la republique du Senegal el le Mouvement des forces democratique de la Casamace (MFDC)
replace agtid=642  if paid==1284
*Sudan Comprehensive Peace Agreement
replace agtid=337  if paid==1282
*Pretoria Agreement on the Peace Process in Côte d'Ivoire
replace agtid=489  if paid==1273
*Agreement between the GoS and the NDA (Cairo Agreement)
replace agtid=1060  if paid==1351
*Memorandum of Understanding between the Government of the Republic of Indonesia and the Free Aceh Movement
replace agtid=450  if paid==1276
*Yebibou agreement 2005 (chad)
replace agtid=.  if paid==1274
*Darfur Peace Agreement
replace agtid=350  if paid==1334
*Ceasefire Code of Conduct
replace agtid=85  if paid==1438
*The Greentree agreement
replace agtid=240  if paid==1333
*The Eight-point SPA-Maoist Agreement
replace agtid=86  if paid==1437
*Agreement of Principles Towards Lasting Peace, Security and Stability
replace agtid=702  if paid==1335
*Memorandum of Understanding on Peace and National Reconciliation in Cabinda province
replace agtid=1336 if paid==1353
*Comprehensive Ceasefire Agreement between the Government of Burundi and the Palipehutu-FNL
replace agtid=336  if paid==1336
*Decisions of the Summit Meeting of the Seven-Party Alliance and the Communist Party of Nepal (Maoist)
replace agtid=87  if paid==1436
*Comprehensive Peace Agreement, 2006
replace agtid=333  if paid==1337
*Tripoli accord (chad)
replace agtid=.  if paid==1338
*Ouagadougou Political Agreement
replace agtid=119  if paid==1359
*First Complementary Agreement to the Ouagadougou Political Agreement
replace agtid=1261  if paid==1360
*Birao Agreement
replace agtid=760  if paid==1355
*Agreement on Comprehensive Solutions between the Government of the Republic of Uganda and Lord's Resistance Army/Movement
replace agtid=888  if paid==1367
*Agreement on Accountability and Reconciliation between the Government of the Republic of Uganda and the Lord's Resistance Army/Movement
replace agtid=137  if paid==1368
*Israeli-Palestinian Joint Understanding on Negotiations
replace agtid=1072  if paid==1354
*Second Complementary Agreement to the Ouagadougou Political Agreement
replace agtid=674  if paid==1361
*Third Complementary Agreement to the Ouagadougou Political Agreement
replace agtid=673  if paid==1362
*Annex to the accountability and reconciliation protocol
replace agtid=667  if paid==1377
*Implementation protocol to the Agreement on Comprehensive Solutions
replace agtid=695  if paid==1378
*Agreement on a Permanent ceasefire
replace agtid=694  if paid==1379
*Agreement on Disarmament, Demobilisation and Reintegration
replace agtid=685  if paid==1380
*Agreement on Implementation and Monitoring Mechanisms
replace agtid=692  if paid==1381
*Accord de Paix Global entre le Gouvernement de la Republique Centrafricaine et les Mouvements politico-militaires centrafricains designes ci-apres: APRD, FDPC, UFDR
replace agtid=669  if paid==1373
*Djibouti Agreement
replace agtid=825  if paid==1374
*Decision of the High Level Committee, Djibouti Agreement
replace agtid=686  if paid==1385
*Declaration of the Summit of the Heads of State and Government of the Great Lakes region on the Burundi Peace Process
replace agtid=712  if paid==1386
*Fourth Complementary Agreement to the Ouagadougou Political Agreement
replace agtid= 720 if paid==1376
*23 March 2009 Agreement
replace agtid=722  if paid==1384
*Doha Agreement
replace agtid=715  if paid==1430
*Agreement between the State of Eritrea and the Republic of Djibouti
replace agtid=721  if paid==1432
*Addis Ababa Agreement
replace agtid=852  if paid==1050
*Cairo Agreement
*replace agtid=1060  if paid==1352
drop if agtid==.

destring conflict_id, replace
save "UCDP_PA_data_final.dta", replace
